﻿CREATE TRIGGER [tr_Borrower_Insert]
ON [dbo].[t_Borrower]
FOR INSERT
AS

INSERT INTO t_Address(BorrowerID,AddressTypeID,Pos)SELECT ID,1,0 FROM inserted
INSERT INTO t_Address(BorrowerID,AddressTypeID,Pos)SELECT ID,1,1 FROM inserted
INSERT INTO t_Employment(BorrowerID,Pos)SELECT ID,0 FROM inserted
INSERT INTO t_Employment(BorrowerID,Pos)SELECT ID,1 FROM inserted
INSERT INTO t_CreditInfo(BorrowerID)SELECT ID FROM inserted
